Chris Pollett > Old Classes > CS185c
( Print View )

Student Corner:
  [Grades Sec1]

  [Submit Sec1]

  [Class Sign Up Sec1]

  [Lecture Notes]
  [Discussion Board]

Course Info:
  [Texts & Links]
  [Topics/Outcomes]
  [Outcomes Matrix]
  [Grading]
  [HW/Quiz Info]
  [Exam Info]
  [Regrades]
  [Honesty]
  [Additional Policies]
  [Announcements]

HWs and Quizzes:
  [Hw1]  [Hw2]  [Hw3]
  [Hw4]  [Hw5]  [Quizzes]

Practice Exams:
  [Mid]  [Final] 

                           












HW#1 --- last modified February 17 2019 19:37:49..

Solution set.

Due date: Feb 9

Files to be submitted:
  Hw1.zip

Purpose:The lab part of this assignment will help you: Learn to logon to z/OS. Learn to use SPUFI and "DB2 Control Center". Learn to create a DB2 database and tablespaces as well as query the DB2 system catalog. The written part will help you understand DB2 architecture, components, and the DB2 environment.

Related Course Outcomes:

The main course outcomes covered by this assignment are:

(1) Identify DB2 components and understand DB2 architecture.
(2) Describe the system environment of DB2 on z/OS, understand how DB2 cooperates with other facilities within this environment.

Specification:

Your Hw1.zip file should contain two main files: Assignment.html and Lab.php . The assignment file should contain your solutions to the multiple choice problems below. The lab file should contain transcripts and screenshots from your SPUFI and control center sessions as well as anything else needed to assignment the lab portion of the assignment.

Assignment Component

For this portion you should answer the following multiple choice problems. To do this you might need to examine the online DB2 Reference Center. Besides choosing what you think is the correct answer to each question you should provide a short explanation in your own words justifying your answer. An answer without a coherent justification will not receive any credit.

  1. Which of the following below is NOT a benefit of 64-bit storage:
    1. It increases capacity of virtual memory and eliminates most storage constraints.
    2. It increases the real memory.
    3. It greatly improves the virtual addressability.
    4. It simplifies the storage management.
  2. DB2 provides service to which of the following via attachment facility?
    1. CICS
    2. IMS
    3. TSO
    4. WebSphere
    5. Another DB2
    6. Windows and Unix
    1. i, ii, iii
    2. i, ii, iii, iv
    3. i, ii, iii, iv, v
    4. All of the above
  3. What information is stored in a DBD?
    1. Recovery data
    2. User data
    3. User and system data
    4. Meta data of the database
  4. Which one below is used to organize disk volumes?
    1. Database
    2. Storage group
    3. Table space
    4. Table
  5. What data is stored in the buffer pool?
    1. BSDS
    2. User data
    3. Log data
    4. All data
  6. Which database is the DB2 catalog stored in?
    1. DSNDB01
    2. DSNDB04
    3. DSNDB06
    4. DSNDB07
  7. Which database is the DB2 directory stored in?
    1. DSNDB01
    2. DSNDB04
    3. DSNDB06
    4. DSNDB07
  8. What is the command for a DB2 user to query the DB2 directory?
    1. Display
    2. Select
    3. Show
    4. No DB2 user can access the DB2 directory.
  9. What is the usage of dynamic statement cache?
    1. Cache dynamic SQL statement result set
    2. Improve the runtime performance of dynamic SQL statements.
    3. Cache dynamic SQL statement prepared result
    4. Cache dynamic SQL accessed data buffer
  10. What type of log is recorded for an SQL SELECT statement?
    1. No log record is written
    2. Undo log is written
    3. Redo log is written
    4. Select log is written

Lab Component

To do the lab component, first join the class discussion board and then download the two lab documents that Varian has posted. Go through the labs answering the question. Keep a transcript of your SPUFI sessions and take png or jpg screenshots of your DB2 Control center activities. Put these all into Lab.html .

To keep the file sizes small for the homework, your solutions should be in html (the language of web pages). I want you to hand-code your html so it doesn't have any bogus mark-up which can make it larger and not work correctly. Here is a basic template file: 

<html>
<head>
<title>Hw1 Template File</title>
</head>
<body>

<h1>Example Heading for a Problem</h1>

<p>
Example paragraph with problem description. 
</p>

<h2>A multiple choice list</h2>
<ol>
<li>Choice 1</li>
<li>Choice 2</li>
<li>Choice 3</li>
</ol>

<p>Use ul tags if you want unordered lists.</p>

<p>An example solution</p>

<h1>The next problem...</h1>

<pre>
PRE tags can be used to put transcripts
of your SPUFI sessions.
</pre>

<img src="filename.png" alt="If you need to add an image
   use an img tag like this and make sure you include the image
   files. All your images should be either png or jpg no bigger
   that 640x480" />

<p>To see what your html file looks like just open it in a browser.</p>
</body>
</html>

Point Breakdown

Assignment component (1/2 point each problem provided the choice was correct and a reasonable justification of your answer was given) 5 pts
Lab.html (material for Lab 1 -- 1pt SPUFI part; 1pt control center part) 2 pts
Lab.html (material for Lab 2) 3 pts
Total10pts